/*    */ package com.yc.dao.export;
/*    */ 
/*    */ import btsm.bean.dbConnector;
/*    */ import com.yc.dao.model.BTSNewBO;
/*    */ import com.yc.util.FormateSQL;
/*    */ import java.sql.ResultSet;
/*    */ import java.util.ArrayList;
/*    */ import java.util.List;
/*    */ import org.apache.commons.logging.Log;
/*    */ import org.apache.commons.logging.LogFactory;
/*    */ 
/*    */ public class BTSExportDao
/*    */   implements IExportAll
/*    */ {
/* 19 */   private static final Log log = LogFactory.getLog(BTSExportDao.class);
/*    */ 
/*    */   public List export(dbConnector dbcon, String strBtsName, String strRegistBeginTime, String strRegistEndTime) {
/* 22 */     ResultSet rs = null;
/* 23 */     List list = new ArrayList();
/*    */     try
/*    */     {
/* 26 */       String strSQL = " select * from bts_new where btsname like '%" + strBtsName + "%'";
/* 27 */       strSQL = FormateSQL.getFormateSQL(strRegistBeginTime, strRegistEndTime, strSQL);
/* 28 */       log.info(strSQL);
/* 29 */       rs = dbcon.execQuery(strSQL);
/* 30 */       while (rs.next()) {
/* 31 */         BTSNewBO bo = new BTSNewBO();
/* 32 */         bo.setId(rs.getString("id"));
/* 33 */         bo.setBtsname(rs.getString("btsname"));
/* 34 */         bo.setFrequency(rs.getString("frequency"));
/* 35 */         bo.setBtscode(rs.getString("btscode"));
/* 36 */         bo.setBSC(rs.getString("BSC"));
/* 37 */         bo.setManufacturer(rs.getString("manufacturer"));
/* 38 */         bo.setCabinet(rs.getString("cabinet"));
/* 39 */         bo.setPrimdevicetype(rs.getString("primdevicetype"));
/* 40 */         bo.setBtscfg(rs.getString("btscfg"));
/* 41 */         bo.setFrequencyNum(rs.getString("frequencyNum"));
/* 42 */         bo.setCombinerType(rs.getString("combinerType"));
/* 43 */         bo.setCombinerNum(rs.getString("combinerNum"));
/* 44 */         bo.setPrimContrmodel(rs.getString("primContrmodel"));
/* 45 */         bo.setPrimContrNum(rs.getString("primContrNum"));
/* 46 */         bo.setPowerPanelType(rs.getString("powerPanelType"));
/* 47 */         bo.setPowerPanelNum(rs.getString("powerPanelNum"));
/* 48 */         bo.setPowerType(rs.getString("powerType"));
/* 49 */         bo.setEle2Mnum(rs.getString("ele2Mnum"));
/* 50 */         bo.setRegisttime(rs.getDate("registtime"));
/* 51 */         bo.setAntennaType(rs.getString("antennaType"));
/* 52 */         bo.setAntennaFac(rs.getString("antennaFac"));
/* 53 */         bo.setAntennaNum(rs.getString("antennaNum"));
/* 54 */         bo.setAntennaGain(rs.getString("antennaGain"));
/* 55 */         bo.setAntennaDirect(rs.getString("antennaDirect"));
/* 56 */         bo.setAntennaPolar(rs.getString("antennaPolar"));
/* 57 */         bo.setAntennaHeight(rs.getString("antennaHeight"));
/* 58 */         bo.setAntennaPre(rs.getString("antennaPre"));
/* 59 */         bo.setAntennaAngle(rs.getString("antennaAngle"));
/* 60 */         bo.setAntennaPitchAngle(rs.getString("antennaPitchAngle"));
/* 61 */         bo.setFeederType(rs.getString("feederType"));
/* 62 */         bo.setOther1(rs.getString("other1"));
/* 63 */         bo.setOther2(rs.getString("other2"));
/* 64 */         bo.setOther3(rs.getString("other3"));
/* 65 */         bo.setOther4(rs.getString("other4"));
/* 66 */         bo.setIDUType(rs.getString("IDUType"));
/* 67 */         bo.setIDUNum(rs.getString("IDUNum"));
/* 68 */         bo.setODUType(rs.getString("ODUType"));
/* 69 */         bo.setODUNum(rs.getString("ODUNum"));
/* 70 */         bo.setRefreshtime(rs.getDate("refreshtime"));
/* 71 */         bo.setMemo(rs.getString("memo"));
/* 72 */         list.add(bo);
/*    */       }
/*    */     }
/*    */     catch (Exception e) {
/* 76 */       e.printStackTrace();
/* 77 */       log.error(e.getMessage());
/*    */     }
/* 79 */     return list;
/*    */   }
/*    */ }

/* Location:           E:\java\apache-tomcat-6.0.36\webapps\btsm\WEB-INF\classes\
 * Qualified Name:     com.yc.dao.export.BTSExportDao
 * JD-Core Version:    0.6.2
 */